﻿CREATE TABLE [dbo].[CLM_837I_2000B_Subscriber]
(
[IDKey] [int] NOT NULL IDENTITY(1, 1),
[Subscriber_HL01_HierarchicalIDNumber] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Subscriber_HL02_HierarchicalParentIDNumber] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Subscriber_HL03_HierarchicalLevelCode] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Subscriber_HL04_HierarchicalChildCode] [nvarchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Subscriber_SBR01_PayerResponsibilitySequenceNumberCode] [nvarchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Subscriber_SBR02_IndividualRelationshipCode] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Subscriber_SBR03_InsuredGroupOrPolicyNumber] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Subscriber_SBR04_InsuredGroupName] [nvarchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Subscriber_SBR09_ClaimFilingIndicatorCode] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Subscriber_NM101_EntityIdentifierCode] [nvarchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Subscriber_NM102_EntityTypeQualifier] [nvarchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Subscriber_NM103_SubscriberLastOrOrganizationName] [nvarchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Subscriber_NM104_SubscriberFirstName] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Subscriber_NM105_SubscriberMiddleName] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Subscriber_NM107_SubscriberNameSuffix] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Subscriber_NM108_IdentificationCodeQualifier] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Subscriber_NM109_SubscriberPrimaryIdentifier] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Subscriber_N301_1SubscriberAddressLine1] [nvarchar] (55) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Subscriber_N302_1SubscriberAddressLine2] [nvarchar] (55) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Subscriber_N301_2SubscriberAddressLine1] [nvarchar] (55) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Subscriber_N302_2SubscriberAddressLine2] [nvarchar] (55) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Subscriber_N401_SubscriberCityName] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Subscriber_N402_SubscriberStateCode] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Subscriber_N403_SubscriberPostalCode] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Subscriber_N404_SubscriberCountryCode] [nvarchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Subscriber_DMG02_SubscriberGenderCode] [nvarchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Subscriber_DMG03_SubscriberBirthDate] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Subscriber_REF02_SubscriberSupplementalIdentifier] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Subscriber_REF02_SubscriberPropertyCasualtyClaimNumber] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Subscriber_NM101_SubscriberCCEntityIdentiferCode] [nvarchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Subscriber_NM102_SubscriberCCEntityTypeQualifier] [nvarchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CreditCard_NM103_CreditOrDebitCardHolderLastOrOrganizationalName] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CreditCard_NM104_CreditOrDebitCardHolderFirstName] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CreditCard_NM105_CreditOrDebitCardHolderMiddleName] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CreditCard_NM107_CreditOrDebitCardHolderNameSuffix] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CreditCard_NM108_CreditOrDebitIdentificationCodeQualifier] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CreditCard_NM109_CreditOrDebitCardNumber] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Payer_NM101_PayerEntityIdentifierCode] [nvarchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Payer_NM102_PayerEntityTypeQualifier] [nvarchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Payer_NM103_PayerLastOrOrganizationName] [nvarchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Payer_NM108_PayerIdentificationCodeQualifier] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Payer_NM109_PayerIdentificationCode] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Payer_N301_PayerAddressLine1] [nvarchar] (55) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Payer_N302_PayerAddressLine2] [nvarchar] (55) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Payer_N401_PayerCityName] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Payer_N402_PayerStateCode] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Payer_N403_PayerPostalCode] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Payer_N404_PayerCountryCode] [nvarchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResponsibleParty_NM101_ResponsiblePartyEntityIdentifierCode] [nvarchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResponsibleParty_NM102_ResponsiblePartyEntityTypeQualifier] [nvarchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResponsibleParty_NM103_ResponsiblePartyLastOrOrganizationName] [nvarchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResponsibleParty_NM104_ResponsiblePartyFirstName] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResponsibleParty_NM105_ResponsiblePartyMiddleName] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResponsibleParty_NM107_ResponsiblePartySuffixName] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResponsibleParty_N301_ResponsiblePartyAddressLine1] [nvarchar] (55) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResponsibleParty_N302_ResponsiblePartyAddressLine2] [nvarchar] (55) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResponsibleParty_N401_ResponsiblePartyCityName] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResponsibleParty_N402_ResponsiblePartyStateCode] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResponsibleParty_N403_ResponsiblePartyPostalCode] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResponsibleParty_N404_ResponsiblePartyCountryCode] [nvarchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ST01_EDIMessageType] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BTSMessageID] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BTSInterchangeID] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]


